create external table jms_ods.tab_sign_type_keyword
(
  ID                 bigint,
  CONFIG_ID           bigint,
  SEND_SIGN_TYPE      string,
  SEND_SIGN_TYPE_CODE string,
  LABEL_TYPE          string,
  KEYWORD             string,
  STATUS              tinyint
)comment '签收类型关键字映射表'
 PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
 stored as parquet
    LOCATION
   '/dw/hive/jms_ods.db/external/tab_sign_type_keyword'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)